class CreateUserDetails < ActiveRecord::Migration
  def self.up
    create_table :user_details do |t|
      t.column :user_id, :integer, :null => false
      t.column :sex_id, :integer,:default => 0
      t.column :somatotype_id, :integer, :default => 0
      t.column :birthday, :date
      t.column :marriage_id, :integer, :default => 0
      t.column :constellation_id, :integer,:default => 1
      t.column :qq, :string, :limit => 16
      t.column :qq_secrecy_id, :integer, :default => 0
      t.column :msn, :string, :limit => 32
      t.column :msn_secrecy_id, :integer, :default => 0
      t.column :indestry_id, :integer
      t.column :profession_id, :integer
      t.column :college, :string, :limit => 32
      t.column :home_page, :string, :limit => 128
      t.column :interest, :string, :limit => 128
      t.column :movie, :string, :limit => 128
      t.column :music, :string, :limit => 128
      t.column :literature, :string, :limit => 128
      t.column :food, :string, :limit => 128
    end
  end

  def self.down
    drop_table :user_infos
  end
end
